AND

This function returns TRUE if all its arguments evaluate to TRUE; returns FALSE if one or more arguments evaluate to FALSE. Most commonly used in the Tripwire formula.

AND(logical1, [logical2], ...)

  • logical1 (Required) is the first condition that you want to test that can evaluate to either TRUE or FALSE.
  • logicial2, ... (Optional) are the additional conditions that you want to test that can evaluate to either TRUE or FALSE.

Example : AND( ActivityType="Normal", ActivityStatus<>"Complete") returns TRUE if the activity type is "NORMAL" and activity status is not equal to "COMPLETE".